Printing a List of Selling Prices

1. Follow the instructions in Setting Selling Prices to Step #7. Command options appear; select Print(X).

2. The following command options will appear:

• Price Report – Select Price Report to print a list of selling prices. The following message will display: "Print Lots? No/Yes."
  • Select no if you do not want to include lots in the report.
  • Select yes if you want to include lots in the report.
• Variance Report – Select Variance Report to print a list of selling prices that are outside a user defined range. A Variance Report Specification window will appear.
  • At the Base Price to Compare Against (1-8) field, enter the base price to compare against the current base selling price to generate the variance for the report.
  • Enter the variance percentage in the Desired Tolerance field.

3. Command options will appear allowing you to print or choose from a set of other print options .

The following information will display for a price report without lot detail:

• Grp – The item group
• Item – The item name
• Cost – The cost of the item, based on the costing method selected and unit of measure
• Markup – The amount of markup per unit based on the Item Markup 1-4 selected
• Price – The base selling price of the item and unit of measure
• A column with a "__________" to be used to write down the new base selling price, if the price will be calculated outside of Net•Yield.
• Profit – The profit per unit based on the base selling price minus cost
• Margin – The gross profit margin percentage
• Onhand – The current on-hand balance and stocking unit of measure.

The following information will display for a price report with lot detail:

• Grp – The item group
• Item – The item name
• Loc – The location of the item, if the item is lotted
• Lot – The lot number, if the item is lotted
• Date – The date the lot was received
• On Hand – The current on-hand balance
• Avail – The current available balance for the lot
• Un Cost – The unit cost for the lot in the invoicing unit of measure
• COOL – The country of origin (COOL)
• Item info lot attributes for each lot
• Cost – The cost of the item, based on the costing method selected and unit of measure
• Markup – The amount of markup per unit based on the Item Markup 1-4 selected
• Price – The base selling price of the item and the unit of measure
• A column with a " ___________" to be used to write down the new base selling price, if the price will be calculated outside of Net•Yield.
• Profit – The profit per unit based on the base selling price minus cost
• Margin – The gross profit margin percentage
• Onhand – The current on-hand balance and stocking unit of measure.

The following information will print for a variance report:

• The date and time of the report, the base price used, and variance tolerance percentage will appear at the top of the report.
• Grp – The item group
• Item – The item name
• For the base price selected and costing method used:
  • Cost – The cost of the item, based on the costing method selected and unit of measure
  • Markup – The amount of markup per unit, based on the Item Markup 1-4 selected
  • Yield – The yield used to calculate the cost of the item
  • Margin – The gross profit margin percentage
  • Price – The base selling price of the item and unit of measure
  • Base Price – (the base price chosen to compare against) – The base selling price selected and unit of measure
  • Difference – The per unit difference between the two base selling prices
  • % – The percentage difference between the two base selling prices.

For more information on the Set Selling Prices option see Set Selling Prices.

Security Required : Sales - Selling Prices